Normal Form
Q2.
If every non-key attribute functionally dependent on the primary key, then the relation will be inQ4.
A database of resear charticles in a journal uses the following schema. Which is the weakest normal form that the new database satisfies,but the old one does not?Q5.
The following functional dependencies hold true for the relational schema R{V,W,X,Y,Z}: V \rightarrowW VW \rightarrowX Y\rightarrow VX Y \rightarrowZ Which of the following is irreducible equivalent for this set of functional dependencies ?Q6.
Suppose the following functional dependencies hold on a relation U with attributes P, Q, R, S, \text{ and } T: P \rightarrow QR \\ RS \rightarrow T Which of the following functional dependencies can be inferred from the above functional dependencies?[MSQ]Q7.
Consider the schema R(A,B,C,D) and the functional dependencies A \rightarrow B and C \rightarrow D. If the decomposition is made as R_{1}(A, B) and R_{2}(C, D), then which of the following is TRUE?Q8.
Consider the following four relational schemas. For each schema, all non-trivial functional dependencies are listed. The underlined attributes are the respective primary keys. Which one of the relational schemas above is in 3NF but not in BCNF?Q9.
For a database relation R(a,b,c,d) where the domain of a,b,c and d include only atomic value, only the following functions dependencies and those that can be inferred from them holda\rightarrowcb\rightarrowdThe relation is in:Q10.
Every time the attribute A appears, it is matched with the same value of attribute B but not the same value of attribute C. Which of the following is true?